Entity DefinitionLogical Name : EmailAddress |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| EmailAddressID (PK) | A unique system assigned identifier for an electronic address for sending messages. | ID_EM_ADS | Identity | integer | |
| EmailAddressLocalPart | The local-part portion is a domain-dependent string. In addresses, it is simply interpreted on the particular host as a name of a particular mailbox. | EM_ADS_LOC_PRT | EmailAddress | varchar(253) | |
| EmailAddressDomainPart | The domain portion identifies the point to which the mail is delivered. In the dot-atom form, this is interpreted as an Internet domain name (either a host name or a mail exchanger name) as described in [RFC1034], [RFC1035], and [RFC1123]. In the domain-literal form, the domain is interpreted as the literal Internet address of the particular host. In both cases, how addressing is used and how messages are transported to a particular host is covered in separate documents, such as [RFC5321]. | EM_ADS_DMN_PRT | EmailAddress | varchar(253) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| EmailAddress | is contact for | RetailTransactionDeliveryPreference |
| EmailAddress | isa | PartyContactMethod |
| EmailAddress | is used by | SiteContactMethod |